AdTerm

Logical Entity Name | AdTerm
Default Table Name | AdTerm
Physical Only | NO
Owner | dbo
Definition |
Note |

AdTerm Columns

ColumnName | Domain | Datatype | NULL | Definition
Code |  | char(16) | NO |
Descrip |  | char(35) | NO |
SyCampusGrpID |  | int | NO |
StartDate |  | datetime | YES |
EndDate |  | datetime | YES |
AdShiftID |  | int | NO |
ModFlag |  | char(1) | NO |
Active |  | bit | NO |
Userid |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdTermID |  | int | NO |
GlobalExtractTerm |  | bit | YES |
AddDropDate |  | datetime | YES |
StudentRegEndDate |  | datetime | YES |
StudentRegStartDate |  | datetime | YES |
RevenueUnits |  | numeric(5, 2) | YES |
TermOpen |  | bit | NO |
AttendanceRecorded |  | bit | NO |
OpenRegistrationBeginDateTime |  | datetime | YES |
OpenRegistrationEndDateTime |  | datetime | YES |
InternalRegistrationBeginDateTime |  | datetime | YES |
InternalRegistrationEndDateTime |  | datetime | YES |
ChildTermDatesRule |  | bit | NO |
SAPTerm |  | bit | NO |
TermUsage |  | smallint | NO |
LMSSendCourseSectionData |  | bit | NO |
LMSSendCourseSectionDataInitialDone |  | bit | NO |
LMSSendInstructorAssignments |  | bit | NO |
LMSSendInstructorAssignmentsInitialDone |  | bit | NO |
LMSSendStudentRegistrationData |  | bit | NO |
LMSSendStudentRegistrationDataInitialDone |  | bit | NO |
AuditDesignationDeadline |  | datetime | YES |
SaCourseRefundPolicyID |  | int | YES |
CampusLinkAmbassadorLiftTermSuspend |  | bit | NO |
SapCalcDaysAfterTermEnd |  | int | YES |
AllowOnlineUsage |  | bit | NO |
RetainLDA |  | bit | YES |
ScheduleChangesType |  | char(1) | YES |
NoOfDaysToRecalcNotification |  | int | YES |
TermRequiresPrePull |  | bit | NO |
NoOfDaysPriorToTermStartDate |  | int | YES |
NoOfDaysAfterTermStartDate |  | int | YES |
StandardTerm |  | tinyint | NO |
StandardTermType |  | char(1) | YES |
FaAcademicCalendar |  | smallint | YES |
CrmSuppressFlag |  | bit | NO |
adTermGroupID |  | int | YES |
SummerHeaderOrTrailer |  | tinyint | NO |
Intersession |  | bit | NO |
InstructionalWeeks |  | int | YES |

AdTerm Primary and Unique Keys

Key Name | Key Type | Keys
AdTerm_Active_SyCampusGrpId_AdTermId_U_N_IDX | Index | Active, SyCampusGrpID, AdTermID
AdTerm_TermUsage_SyCampusGrpId_Descrip_Code_AdTermID_StartDate_EndDate_Active_TermOpen_U_N_IDX | Index | TermUsage, SyCampusGrpID, Descrip, Code, AdTermID, StartDate, EndDate, Active, TermOpen
AdTerm_AdTermID_U_C_IDX | PrimaryKey | AdTermID

AdTerm Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
adTermGroup | Non-Identifying | Zero or One to Zero or More | FK_adTermadTermGroupId_adTermGroupadTermGroupId |  |  | adTermGroupID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdEnrollTermConfirm | Non-Identifying | One To Zero or More | AdEnrollTermConfirm_AdTermId_AdTerm_AdTermId |  |  |  | NO | YES
AmCollegeTransfer | Non-Identifying | One To Zero or More | FK__AmCollege__AdTer__63DC2D9B |  |  |  | NO | YES
AdEnrollHonors | Non-Identifying | One To Zero or More | FK_AdEnrollHonors_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdEnrollRegistration | Identifying | One To Zero or More | FK_AdEnrollRegistration_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdEnrollRegistrationGroup | Non-Identifying | One To Zero or More | FK_AdEnrollRegistrationGroup_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdEnrollRegTerm | Non-Identifying | One To Zero or More | fk_AdEnrollRegTerm_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdEnrollSchedStatusChanges | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusChangesParentTermID_AdTermAdTermID |  |  |  | NO | YES
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusHistory_ParentTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdEnrollTermRelationship | Non-Identifying | One To Zero or More | FK_AdEnrollTermRelationship_ParentAdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdGPAStudent | Non-Identifying | One To Zero or More | FK_AdGPAStudentAdParentTermID_AdTermAdTermID |  |  |  | NO | YES
AdGPAStudent | Non-Identifying | One To Zero or More | FK_AdGPAStudentAdTermID_AdTermAdTermID |  |  |  | NO | YES
AdRegistrationGroupTerm | Non-Identifying | One To Zero or More | FK_AdRegistrationGroupTerm_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdRegistrationLock | Non-Identifying | One To Zero or More | FK_AdRegistrationLockAdTermID_AdTermAdTermID |  |  |  | NO | YES
AdSapQueue_Detail | Non-Identifying | One To Zero or More | FK_AdSapQueue_Detail_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdStartTerm | Non-Identifying | One To Zero or More | FK_AdStartTerm_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdStudentTermSequenceHeader | Non-Identifying | One To Zero or More | FK_AdStudentTermSequenceHeader_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdTermCampusRelationship | Non-Identifying | One To Zero or More | FK_AdTermCampusRelationship_AdTermID_AdTerm_AdTermID |  |  |  | NO | NO
adTermExternalMap | Non-Identifying | One To Zero or More | FK_adTermExternalMapadTermId_adTermadTermId |  |  |  | NO | YES
AdTermOnLineRegistration | Identifying | One To Zero or More | FK_AdTermOnlineRegistration_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdTermProgramAssociation | Non-Identifying | One To Zero or More | FK_AdTermProgramAssociationAdTermID_AdTermAdTermID |  |  |  | NO | YES
AdTermRelationship | Non-Identifying | One To Zero or More | FK_AdTermRelationship.ChildAdTermID_AdTerm.AdTermID |  |  |  | NO | YES
AdTermRelationship | Non-Identifying | One To Zero or More | FK_AdTermRelationship.ParentAdTermID_AdTerm.AdTermID |  |  |  | NO | YES
adTermRelationshipModifyLog | Non-Identifying | One To Zero or More | FK_adTermRelationshipModifyLog_AddedParentTermID_AdTerm_AdTermID |  |  |  | NO | YES
adTermRelationshipModifyLog | Non-Identifying | One To Zero or More | FK_adTermRelationshipModifyLog_ChildParentAdTermID_AdTerm_AdTermID |  |  |  | NO | YES
adTermRelationshipModifyLog | Non-Identifying | One To Zero or More | FK_adTermRelationshipModifyLog_RemovedParentAdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AdTermSequenceStartDate | Non-Identifying | One To Zero or More | FK_AdTermSequenceStartDate_AdTSStartDateTermID_AdTerm_AdTermID |  |  |  | NO | YES
AmCollegeTransferAdvance | Non-Identifying | One To Zero or More | FK_AmCollegeTransferAdvance_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
AmDeposit | Non-Identifying | One To Zero or More | Fk_AmDeposits_AdTermid_AdTerm_AdTermID |  |  |  | NO | YES
CmDocumentPermit | Non-Identifying | One To Zero or More | FK_CmDocumentPermitAdTermID_AdTermAdTermID |  |  |  | NO | YES
FaGlobalExtractChildTerm | Non-Identifying | One To Zero or More | FK_FaGlobalExtractChildTerm_AdTermId_AdTerm_AdTermId |  |  |  | NO | YES
FaIntersessionTermRegistration | Non-Identifying | One To Zero or More | FK_FaIntersessionTermRegistration_IntersessionTermId_AdTerm_AdTermId |  |  |  | NO | YES
FaIntersessionTermRegistration | Non-Identifying | One To Zero or More | FK_FaIntersessionTermRegistration_ParentTermId_AdTerm_AdTermId |  |  |  | NO | YES
FaStudentFundPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentFundPaymentPeriodAdTermId_AdTermAdTermId |  |  |  | NO | YES
FaTermTrack | Non-Identifying | One To Zero or More | FK_FaTermTrack_AdTermId_AdTerm_FaTermAssociationTrackId |  |  |  | NO | YES
FaTermTrackProgramAssociation | Non-Identifying | One To Zero or More | FK_FaTermTrackProgramAssociation_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
HsRoomMateMatchCriteria | Non-Identifying | One To Zero or More | FK_HsRoomMateMatchCriteria_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
HSStudentLeaseChargeSchedule | Non-Identifying | One To Zero or More | FK_HsStudentLeaseChargeSchedule_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
HSStudentLeaseHistory | Non-Identifying | One To Zero or More | FK_HSStudentLeaseHistory_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
HSStudentLeaseHistory | Non-Identifying | One To Zero or More | FK_HsStudentLeaseHistorySaBillTermID_AdTermAdTermID |  |  |  | NO | YES
SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetail_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaBillingStatementBatchStudent | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchStudent_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaEnrollRevenueChildTerm | Non-Identifying | One To Zero or More | FK_SaEnrollRevenueChildTerm_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaPendingCharge | Non-Identifying | One To Zero or More | FK_saPendingCharge.AdTermID_AdTerm.AdTermID |  |  |  | NO | YES
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaPendingChargeRecalcLog | Non-Identifying | One To Zero or More | FK_SaPendingChargeRecalcLog_AdTermId_AdTerm_AdTermID |  |  |  | NO | YES
SaRegBillQueue_Detail | Non-Identifying | One To Zero or More | FK_SaRegBillQueue_Detail_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaRevenueDetail | Non-Identifying | One To Zero or More | FK_SaRevenueDetail_ChildAdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More | FK_SaStudentLedgerTermUpdatesArchive_NewAdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaStudSubsidiaryTrans | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiaryTrans_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaSubsidiaryRefund | Non-Identifying | One To Zero or More | Fk_SaSubsidiaryRefund_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SsAthleticDetail | Non-Identifying | One To Zero or More | FK_SsAthleticDetailAdTermID_AdTermAdTermID |  |  |  | NO | YES
SsStudentServiceAssociation | Non-Identifying | One To Zero or More | FK_SsStudentServiceAssociation_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SsStudentVeteranDetail | Non-Identifying | One To Zero or More | FK_SsStudentVeteranDetailAdTermID_AdTermAdTermID |  |  |  | NO | YES
SyIndicatorStudentRelation | Non-Identifying | One To Zero or More | FK_SyIndicatorStudentRelation_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SyStatChange | Non-Identifying | One To Zero or More | FK_SyStatChange_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES
SyStateReportTermMapping | Non-Identifying | One To Zero or More | FK_SyStateReportTermMapping_AdTermID_AdTerm_AdTermID |  |  |  | NO | YES

AdTerm Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdTerm_OpenRegistrationBeginDateTime_OpenRegistrationEndDateTime | ([OpenRegistrationBeginDateTime] is null and [OpenRegistrationEndDateTime] is null or [OpenRegistrationBeginDateTime] is not null and [OpenRegistrationEndDateTime] is not null and [OpenRegistrationBeginDateTime] <= [OpenRegistrationEndDateTime])
Chk_AdTerm_InternalRegistrationBeginDateTime_InternalRegistrationEndDateTime | ([InternalRegistrationBeginDateTime] is null and [InternalRegistrationEndDateTime] is null or [InternalRegistrationBeginDateTime] is not null and [InternalRegistrationEndDateTime] is not null and [InternalRegistrationBeginDateTime] <= [InternalRegistrationEndDateTime])

AdTerm Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AdTerm Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Term | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdTerm | NO |  |  |

AdTerm Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | CourseRegistration
Logical | DegreePathway
Logical | Documents
Logical | Grades/Attendance
Logical | LedgerCard_Billing
Logical | PreviousEd_TransferCredits
Logical | RefundCalculation
Logical | SubsidiaryLedger
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdTerm Data Movement Rules

Name | Type | Rule Text/Value